﻿//using Kingdee.BOS;
//using Kingdee.BOS.App.Data;
//using Kingdee.BOS.Core.DynamicForm.PlugIn;
//using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
//using Kingdee.BOS.Orm.DataEntity;
//using Kingdee.BOS.Util;
//using System;
//using System.Collections.Generic;
//using System.ComponentModel;
//using System.Data;
//using System.Linq;

//namespace Kingdee.Bos.Project.DyForm
//{

//    [Description("【服务插件】保存前检查单据体物料、价目表是否重复"), HotUpdate]

//    public class JiaGeTiaoZhengBaoCun : AbstractOperationServicePlugIn
//    {

//        public override void BeginOperationTransaction(BeginOperationTransactionArgs e)
//        {
//            base.BeginOperationTransaction(e);
//            foreach (DynamicObject item in e.DataEntitys)
//            {
//                var FBillNo = item["BillNo"].ToString();//编号
//                string SQLselect = "select FBILLNO AS '单据编号',F_VHTP_WLMC AS '物料', " +
//                       " F_VHTP_JM1 AS '价目表1',F_VHTP_DJ11 AS '价目表1调前含税单价',F_VHTP_DJ12 AS '价目表1调后含税单价', " +
//                       " F_VHTP_JM2 AS '价目表2',F_VHTP_DJ21 AS '价目表2调前含税单价',F_VHTP_DJ22 AS '价目表2调后含税单价', " +
//                       " F_VHTP_JM3 AS '价目表3',F_VHTP_DJ31 AS '价目表3调前含税单价',F_VHTP_DJ32 AS '价目表3调后含税单价', " +
//                       " F_VHTP_JM4 AS '价目表4',F_VHTP_DJ41 AS '价目表4调前含税单价',F_VHTP_DJ42 AS '价目表4调后含税单价', " +
//                       " F_VHTP_JM5 AS '价目表5',F_VHTP_DJ51 AS '价目表5调前含税单价',F_VHTP_DJ52 AS '价目表5调后含税单价', " +
//                       " F_VHTP_JM6 AS '价目表6',F_VHTP_DJ61 AS '价目表6调前含税单价',F_VHTP_DJ62 AS '价目表6调后含税单价', " +
//                       " F_VHTP_JM7 AS '价目表7',F_VHTP_DJ71 AS '价目表7调前含税单价',F_VHTP_DJ72 AS '价目表7调后含税单价', " +
//                       " F_VHTP_JM8 AS '价目表8',F_VHTP_DJ81 AS '价目表8调前含税单价',F_VHTP_DJ82 AS '价目表8调后含税单价', " +
//                       " F_VHTP_JM9 AS '价目表9',F_VHTP_DJ91 AS '价目表9调前含税单价',F_VHTP_DJ92 AS '价目表9调后含税单价', " +
//                       " F_VHTP_JM10 AS '价目表10',F_VHTP_DJ101 AS '价目表10调前含税单价',F_VHTP_DJ102 AS '价目表10调后含税单价' " +
//                       " FROM VHTP_t_Cust100006 T1 " +
//                       " LEFT JOIN VHTP_t_Cust_Entry100002 T2 " +
//                       " ON T2.FID = T1.FID " +
//                       " where FBILLNO = '" + FBillNo + "' ";
//                DataTable dt1;
//                dt1 = DBUtils.ExecuteDataSet(this.Context, SQLselect).Tables[0];
//            }
//        }
//    }
//}
